package com.lokyiu.mybible.db.sqlite.def;

import android.database.sqlite.SQLiteDatabase;

public class ChapterColumns implements Columns {

	/**
	 * ------------- CHAPTERS Table
	 */
	// TABLE NAME
	public static final String TABLENAME = "chapters";
	public static final String CHAPTER_BIBLEBOOK = "bookname";
	public static final String CHAPTERS_NUMBER = "chapternum";
	public static final String CREATE_CHAPTERS_TABLE_SQL = "create table "
			+ TABLENAME + "(" + CHAPTER_BIBLEBOOK
			+ " TEXT," + CHAPTERS_NUMBER + " INT" + ", PRIMARY KEY(" + CHAPTER_BIBLEBOOK + "," + CHAPTERS_NUMBER + "))";
	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL(CREATE_CHAPTERS_TABLE_SQL);
	}
	@Override
	public void dropTable(SQLiteDatabase db) {
		db.execSQL("DROP TABLE IF EXISTS " + TABLENAME);
	}
	@Override
	public String getTableName() {
		return TABLENAME;
	}

}
